  create external table jms_dim.dim_tab_forfeit_config_base
(ID  string COMMENT '主键ID',
FEE_TYPE string COMMENT '费用类型',
FEE_START_TIME TIMESTAMP COMMENT '罚款启用时间',
FEE_END_TIME TIMESTAMP COMMENT '罚款结束时间',
FEE_LEVEL string COMMENT '启罚点',
FEE_MONEY_PER DECIMAL(10,2) COMMENT '单笔金额(元)',
FEE_MONEY_UPPER DECIMAL(10,2) COMMENT '罚款上限',
FEE_MONEY_STATUS int COMMENT '罚款状态',
CREATE_BY_NAME string COMMENT '创建人名称',
CREATE_BY_CODE string COMMENT '创建人code',
CREATE_TIME TIMESTAMP COMMENT '创建时间',
UPDATE_TIME TIMESTAMP COMMENT '修改时间',
UPDATE_BY_NAME string COMMENT '修改人名称',
UPDATE_BY_CODE string COMMENT '修改人code',
REMARK string COMMENT '备注',
REMARK2 string COMMENT '预留字段'
)COMMENT '奖罚配置表'
STORED AS parquet
LOCATION
  '/dw/hive/jms_dim.db/external/dim_tab_forfeit_config_base';